﻿USE [Oauth]
GO
/****** Object:  Table [dbo].[Twitter]    Script Date: 06/07/2010 21:00:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Twitter](
	[ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Twitter_ID]  DEFAULT (newid()),
	[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Twitter_CreateDate]  DEFAULT (getdate()),
	[Token] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[TokenSecret] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Password] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Specifier] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
 CONSTRAINT [PK_Twitter] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


/****** Object:  Table [dbo].[TwitterLog]    Script Date: 07/06/2010 13:15:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TwitterLog](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[User] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Agent] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[IP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Content] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL,
 CONSTRAINT [PK_TwitterLog] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
